Lead Datastage Consultant

2 months ago

Brisbane, Australia Carecone Pty. Ltd. Full time

**Primary Skills**:

- 10 + years of experience in implementing full life cycle of data warehousing projects.
- 5+ years of experience in UNIX.
- IBM Infosphere Server DataStage, WebSphere Information Server DataStage, Quality Stage, Information Analyzer, IBM Initiate MDS, IBM Optima, Test Data Management (TDM), Data Masking (DM), Metadata Workbench, Infosphere Meta data Asset Management(IMAM), Informatica, Cognos Framework and Report Studios, PL/SQL,UNIX (AIX, HP-UX,SOLARIES,LINUX), MS-DOS, Windows Server, Dimensional Modeling ERWin, UNIX Shell Scripting, Teradata, DB2, Oracle, ANSI SQL, SQL Server, Toad, SQL Visual studio, SQL Developer, DataStage Director, Control-M, AutoSys, JIRA, and HP Quality Center.

**Secondary Skills**:

- Strong knowledge of Star schema and Snowflake schemas, involved in designing DW concepts like conformed dimensions, conformed facts and Data Warehouse bus architecture for ETL development
- Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing projects
- Experience in being in constant interaction with Data Modelers and Architects, and involved in the process of giving and taking feedback as a part of improving the Data Model so that the Data Model supports the structures needed for ETL development
- 10 plus years of experience in Analysis/Design/Development/Implementation of ETL processes for Data Warehousing/Data Mart using DataStage with multiple database.
- Experience in designing the DataStage Master Design Document for the project and Detail Design Document for a release to guide ETL (Extract, Transform and Load) development
- Expert in establishing DataStage patterns for the project/release in order to allow maximum reusability of the DataStage modules and processes
- Expert knowledge in DataStage best practices and in designing jobs for optimal performance, reusability and restart ability
- Expert in configuring database connections for Oracle, DB2, Sybase and SQL Server from DataStage
- Expert in setting up parallel configuration files depending upon Client’s hardware architecture
- Strong experience in making DataStage processes as repeatable as possible to ensure there are significantly less man hours used, less defect ratio, and ability to deliver a task in less time; and as a result, be more cost effective
- Strong and proven experience in making DataStage ETL processes function as a well - oiled machine with lesser development time required as the project progresses
- Strong working experience in mentoring, training, guiding and leading teams of three to four DataStage developers, experienced and beginners both onsite and offsite
- Data Warehousing implementation experience using DataStage PX (DataStage Designer, DataStage Director, DataStage Manager, DataStage Administrator), DataStage Information Server
- Expertise in implementing DataStage PX, Sequencer, Shared Container jobs
- Strong experience in coding using SQL, PL/SQL Procedures/Functions, Triggers and Packages
- Strong experience in Unix scripting and running DataStage jobs using Unix scripts
- Strong working experience in designing DataStage job scheduling outside the DataStage tool and also within the tool as required by Client/Customer company standards
- Expert in configuring and setting up DataStage PX on AIX, DB2 UDB, Teradata, Oracle and other environments
- Expert in maintaining Metadata at the database level using a combination of DS PX jobs
- Expert in designing the DataStage configuration files for optimal performance and best resource usage
- Worked extensively on different types of stages like Filter, Join, Merge, Lookup, Funnel, Aggregator, Transformer, Sort, CDC stages, Surrogate Key Generator, Modify, Remove Duplicates, Sequential File, Dataset, File set, Copy, Head, Tail, Connector stages for Databases (Teradata, Oracle, DB2), ODBC Connector, Real Time, Shared Containers, Column Import, Column Export, Switch, MQ Connector for developing jobs.
- Worked on several Real Time Stages such as MQ, XML input and XML output etc.
- Worked extensively on sequence Stages - Job Activity, Execute Command, End Loop Activity, Exception Handler, Nested Condition, Notification Activity, Routine Activity, Sequencer, Start Loop Activity, Terminator Activity, User Variables Activity
- Worked IBM Information analyzer for columns analysis, primary key analysis, foreign key analysis and cross-domain analysis
- Install and configure IBM Information server.
- Performed administration tasks like role setup, connectivity, security, configuration of projects, user registries, create or update users and groups, mapping credentials, configuring DSN and TNS entries, parallel, compiler, reporting, operator and user-defined environment variables.
- Configuration of XMETA repository, Node Agents and DS Engine.
- Worked extensively on Teradata BTEQ Scripts to implement CDC process and Table load.
- Working experience in Teradata RDBMS using Fast Load, Multiload,

  • Lead Datastage Consultant

    5 days ago

    Brisbane, Queensland, Australia Carecone Pty. Ltd. Full time

    Primary Skills: 10 + years of experience in implementing full life cycle of data warehousing projects. 5+ years of experience in UNIX. IBM Infosphere Server DataStage, WebSphere Information Server DataStage, Quality Stage, Information Analyzer, IBM Initiate MDS, IBM Optima, Test Data Management (TDM), Data Masking (DM), Metadata Workbench, Infosphere Meta...

  • Tech Lead

    3 weeks ago

    Brisbane, Australia Hawksworth Full time

    DataStage Experience is a requirement to be successful in this role - Competitive day rate - can be based anywhere - Flexible working arrangements - Tech Stack : DataStage | ETL | SQL | DWH | Oracle | DB2 | Redshift Initial 6 month day rate contract with the view to extend (Competitive day rate) - Position can be based in Sydney, Brisbane or Melbourne Tech...

  • Datastage Lead

    6 days ago

    Brisbane, Australia Delivery Centric Technologies Full time

    **Must have**: 5+ years of experience in IT 5+ years as a Data Integration practitioner 2+ years of solid hands-on experience in using IBM DataStage Understand DataStage clustering architecture and parallel jobs Intimate knowledge in combine/sort/aggregate/transform data Experience creating reusable objects and job templates Schedule, compile, and run...

  • Datastage Lead

    5 days ago

    Brisbane, Queensland, Australia Delivery Centric Technologies Full time

    Must have:5+ years of experience in IT5+ years as a Data Integration practitioner2+ years of solid hands-on experience in using IBM DataStageUnderstand DataStage clustering architecture and parallel jobsIntimate knowledge in combine/sort/aggregate/transform dataExperience creating reusable objects and job templatesSchedule, compile, and run DataStage jobs...

  • Tech Lead

    3 days ago

    Brisbane, Australia Ontrack Systems Aus Pty Ltd Full time

    **Location : Brisbane | Sydney | Melbourne** **MUST Have : TECH LEAD - DATA Engineering - experience with DATASTAGE | UNIX | Oracle** ***Worked as Technical Lead / Data Engineer in area of Data Warehousing/Business Intelligence Very hands on heavy on quickly learning Data Application, Data Analysis, Scripting, Data Transformation and Reconciliation. Data...

  • Tech Lead

    2 months ago

    Brisbane, Australia Delivery Centric Technologies Full time

    Hello Folks, We are looking for passionate professionals who are passionate about their job and want to make a difference with their consulting and solutioning skills, who are ready to take challenges and test their skills to provide the best solutions. We are currently looking for the below roles **About Delivery Centric**: Delivery Centric is a...

  • Tech Lead

    5 days ago

    Brisbane, Queensland, Australia Hawksworth Full time

    DataStage Experience is a requirement to be successful in this role Competitive day rate can be based anywhere Flexible working arrangements Tech Stack : DataStage | ETL | SQL | DWH | Oracle | DB2 | RedshiftInitial 6 month day rate contract with the view to extend (Competitive day rate) - Position can be based in Sydney, Brisbane or MelbourneTech Stack :...

  • Tech Lead

    5 days ago

    Brisbane, Queensland, Australia Ontrack Systems Aus Pty Ltd Full time

    Location : Brisbane | Sydney | MelbourneMUST Have : TECH LEAD - DATA Engineering - experience with DATASTAGE | UNIX | Oracle***Worked as Technical Lead / Data Engineer in area of Data Warehousing/Business IntelligenceVery hands on heavy on quickly learning Data Application, Data Analysis, Scripting, Data Transformation and Reconciliation.Data Migration...

  • Tech Stack

    2 weeks ago

    Brisbane, Australia Delivery Centric Technologies Full time

    **Job description** **Role: Tech Stack** Hello Folks, We are looking for passionate professionals who are passionate about their job and want to make a difference with their consulting and solutioning skills, who are ready to take challenges and test their skills to provide the best solutions. We are currently looking for the below roles **About Delivery...

  • Etl Tech Lead

    1 week ago

    Brisbane, Australia Delivery Centric Technologies Full time

    **Role Title - ETL Tech Lead** **Location: Brisbane** **Employment Type - Full Time** **Key Responsibilities**: - Experience in **ETL testing** | Experience in test planning - Experience in **test estimation, creating SQL based test cases, SQL based test execution**: - Experience in writing **Test automation scripts**: - Good working knowledge of ETL...

  • Tech Stack

    5 days ago

    Brisbane, Queensland, Australia Delivery Centric Technologies Full time

    Job descriptionRole: Tech StackHello Folks,We are looking for passionate professionals who are passionate about their job and want to make a difference with their consulting and solutioning skills, who are ready to take challenges and test their skills to provide the best solutions. We are currently looking for the below rolesAbout Delivery Centric:Delivery...

  • Etl Tester

    1 week ago

    Brisbane, Australia GoTech Solutions Pty Ltd Full time

    **About GoSol**: GOSOL, IT consulting and Staffing organization, can help you enhance Technology, Digital, Project and Business Transformation. Guided by integrity and trust, we believe in offering an unparalleled experience as your Tech of choice. For businesses, this means providing you with access to the quality solution. Overall 5+ Years of experience...

  • Etl Test Analyst

    2 months ago

    Brisbane, Australia Delivery Centric Technologies Full time

    **Job description** Hello Folks, We are looking for passionate professionals who are passionate about their job and want to make a difference with their consulting and solutioning skills, who are ready to take challenges and test their skills to provide the best solutions. We are currently looking for the below roles **About Delivery Centric**: Delivery...

  • Lead Consultant

    5 days ago

    Brisbane, Queensland, Australia Proactive Global Full time

    Lead Consultant (Systems Designer and Project Manager)MEL / SYD / BRI basedExpressions of InterestDo you have experience in both designing and project managing the delivery of major automated systems, whether in BHS, warehouse or parcel sortation systems?Do you have excellent client-facing communication skills?Could a role with a highly regarded consultancy,...

  • Lead IT Security Consultant

    2 months ago

    Brisbane, Australia Decipher Bureau Full time

    Brisbane Based - Initial contract up until end Feb 2024 (rolling) - Large program of work for a digital transformation **- - Are you an experienced IT Security Consultant looking for a new challenge?** Decipher Bureau, a renowned cybersecurity recruitment agency, is thrilled to present an exceptional career opportunity for a Lead IT Security Consultant...

  • Lead IT Security Consultant

    16 hours ago

    Brisbane, Australia Decipher Bureau Full time

    Brisbane Based - Initial contract up until end Feb 2024 (rolling) - Large program of work for a digital transformation **- - Are you an experienced IT Security Consultant looking for a new challenge?** Decipher Bureau, a renowned cybersecurity recruitment agency, is thrilled to present an exceptional career opportunity for a Lead IT Security Consultant...

  • Lead IT Security Consultant

    5 days ago

    Brisbane, Queensland, Australia Decipher Bureau Full time

    Brisbane Based Initial contract up until end Feb 2024 (rolling) Large program of work for a digital transformation** Are you an experienced IT Security Consultant looking for a new challenge?**Decipher Bureau, a renowned cybersecurity recruitment agency, is thrilled to present an exceptional career opportunity for a Lead IT Security Consultant within the...

  • Lead Functional Consultant

    2 months ago

    Brisbane, Australia Sonata Australia Pty Limited Full time

    Manage full life cycle of design and testing phases. Develop solution design and lead client throughout implementation and support phases. - Assist customers maximize strategic business value from company products to provide them with vision of their end state solution and roadmap. - Evaluate customer’s business requirements, needs and objectives and...

  • Lead Consultant

    4 weeks ago

    Brisbane, Australia Recruit Shop Full time

    **EARN $130,000 pa + Super + Bonuses | Negotiable Based on Experience**: - **Join an Industry Leading Company Who Are Changing the Future of Transport**: - **Perfect Opportunity For a Fleet Transition Expert to Create a Sustainable Future.**: **About The Company**: Our client is a small team of passionate and driven experts with a goal of creating a more...

  • M365 / Sharepoint - Lead Consultant / Practice Lead

    2 months ago

    Brisbane, Australia ETE Group Full time

    'Step Up' role for 'Gun' M365/SharePoint Consultant - Confidentiality assured **_Please note, we understand the need for confidentiality in the tight-knit M365 world, and our discretion is assured for all applicants._** Are you an experienced Modern Workplace (M365) / SharePoint Consultant who has 'hit the ceiling' and is looking for a chance to step-up...