Sr. ETL Developer

Sr. ETL Developer

Position : Sr. ETL Developer

Job Duties :

Under limited supervision, analyze, design, develop, implement and troubleshoot complex data warehouse application solutions; gather and interpret functional specifications and user requirements to provide technical solutions; develop functional requirements and technical design documentation; coordinate the development of the data mart and data warehouse; perform application data integration development, implement metadata processes and frameworks; implement business rules, create stored procedures, packages, functions and triggers; develop ETL mappings; develop and schedule ETL workflows and complex jobs; create SQL queries; create data mapping and packages to load data from various sources to destination; perform maintenance, execute performance tuning and SQL query tuning; create Hive tables; perform unit and integration testing, troubleshoot scripts and fix bugs; prepare implementation plan and create supporting documents; address production issues; document solutions; prepare user documentation; track change requests; mentor/assist lower level team members; and use UNIX, AIX, Windows, Teradata, Oracle, SQL Server, Erwin, Hadoop, DataStage, Hyperion, Business Objects, DataStage, Hive, Pig, Mapreduce, Java, SQL, PL/SQL, C, C++, TOAD and related tools.

Minimum Qualifications Education

• Master degree in Computer Science, Applied Computer Science, Computer Engineering, Information Systems or in a related field of study (will accept equivalent foreign degree).

• Experience : Two (2) years of experience as a Software Developer, Systems Analyst, Programmer or in a related occupation;

• Other Requirements :

• Experience must include 2 years of work with Oracle, Teradata, DataStage, Hyperion and Business Objects; must be willing to relocate.

• Job Order No : 10046075.

• This position is eligible for a referral bonus through our employee referral program

• Position : Sr. ETL Developer

• Job Duties :

Under limited supervision, develop and implement complex ESB architecture and EAI solutions for application development; responsible for full SDLC; gather requirements, analyze current architecture, reconcile conflicts and suggest improvements and automations to be included; create high level and low-level technical documentation involving supported business functions and corresponding technical strategy benefits, data flow diagrams, proof of concept, security requirements and risks; integrate real time workflows; design and develop reusable transformations, mappings, mapplets, sessions and workflows for integration; create and maintain relational and application connections for different data sources; create and manage message queue, data sources and their properties; schedule jobs and develop data transformation services to convert and integrate formats; establish real-time JMS between applications; develop complex database objects for data transformation and messaging; implement version-controlled code development and maintenance; coordinate functional, system, integration and UAT testing; perform issue tracking; work on bug fixes and enhancements; mentor/assist less experienced team members; and use: Windows, Linux, Oracle, SQL Server, MFT, Informatica, Active MQ, PL/ SQL, Perl and Shell Scripting, Jira, VSS, ClearCase, Atlassian, XML, XSD, JSON and related tools.

Minimum Qualifications Education

• Bachelor degree in Computer Science, Computer/Electronics Engineering, Information Systems or in a related field of study (will accept equivalent foreign degree);

• Experience : Five (5) years of progressive experience as a Software Developer, Systems Analyst, Systems Engineer, Programmer or in a related occupation;

• Other Requirements :

• Experience must include 5 years of work with Linux, Oracle, Informatica, PL/SQL and Perl Scripting; must be willing to relocate.

• Job Order No : 10046074.

• This position is eligible for a referral bonus through our employee referral program

• Position : Sr. ETL Developer

• Employer:

• HCL Global Systems Inc.

• Job Duties :

Design Dimensional data model by identifying business process, Grain and identifying Source and Targets for the project. Translating business logic into mappings using complex transformation logics for ETL processes. Develop Data cleansing and de-dup mappings in Informatica Data Quality (IDQ) and write rules, ETL logics to determine the Golden Record using key generator, matching and consolidator transformations, Master Data Management using match and merge rules. Implementing Data Warehouse/Data mart, Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP), designing Data modeling and creating data warehouse using Ralph Kimball and William Inmon methodologies for Star Schema, Snowflake Schemas respectively. Develop mappings on Cloudera/Hadoop environment using Informatica Big Data Management 10.1.1, 10.2.1 (including Native, Hive, Spark and Blaze engines).Perform both NORMAL/BULK Target load type in informatica power center (PWC). Effectively using Pre-SQL and Post-SQL to drop and recreate indexes. Write Oracle/SQL scripts and stored procedures. Work on different models – waterfall, iterative, and agile methodologies. Develop ETL code in Informatica Power Center mapping, session and workflow to perform core development changes and promote code to production on time to deliver value to business. Work extensively on Unix and Windows platforms.

Work Location :

various unanticipated work locations throughout the United States; relocation may be required. Must be willing to relocate.

Minimum Requirements:

Education : Bachelor’s degree in Computer Science, Electronics Engineering, Computer Information Systems, or closely related field.

Experience:

None

Job Order No : 9573025.

This position is eligible for a referral bonus through our employee referral program

Position : Sr. ETL Developer

Employer:

HCL Global Systems Inc.

Job Duties :

Analyze and estimate application requirements and document recommendations from the subject matter experts on various application resources. Analyze and review shared infrastructure utilization (like database sessions and bandwidth used) and design maintenance schedules minimizing application outage. Participate in JAD (Joint application Design) sessions in designing application architecture collaborating with business analysts, developers and system engineers. Communicate with business users at every step of the design process to ensure correct translation of requirements gathered and documented. Working with project owners and application users to understanding the business requirements to designs and model a solution. Work with Vendors to acquire the necessary software licenses and configuration files for the build. Develop data warehouse process models, including sourcing, extracting, transforming and loading as per business requirements. Develop data warehouse process models, including sourcing, extracting, transforming and loading as per business requirements. Document technical ETL specifications for data warehouse. Perform periodic code reviews and test plans to ensure data quality and integrity. Create ETL mappings, transformations, stored procedures and functions to implement the data process flow defined by the business rules. Organize review meetings with business users and developers to certify a build and pan all necessary updates. Tracking ETL batch run times, review data quality controls and application performance on a weekly basis. Work on incidents and issues raised by the business teams during data validation. Manage job logs, failures, escalations as well as security or audit related items when they affect the production environment. Technical Skills required: IBM IS DataStage, Talend, SSIS, Oracle, SQL server, Exadata, Cassandra, R, Python, Cisco CMX, Cognos, Tableau, Qlikview, etc.

Work Location :

various unanticipated work locations throughout the United States; relocation may be required. Must be willing to relocate.

Minimum Requirements:

Education : Bachelor’s Degree in Computer Science, Computer Information Systems, or a related field.

Experience:

None

Job Order No : 9573102.

This position is eligible for a referral bonus through our employee referral program

Position : Sr. ETL Developer

Job Duties :

• Conceptualize, analyze, develop, and deploy strategies for data acquisition, transformation, and loading on an enterprise level. He will collaborate with key members of the design team to design, build, test, and deploy an environment that supports a single version of the truth, actionable results, and flexibility for the future, performance, data quality, and data governance. On a day-to-day basis he will be responsible to:

• Use Amazon Web Services (AWS) infrastructure services such as EC2, S3, Redshift and Kinesis to conceptualize, develop and deploy strategies for data acquisition, transformation, and loading on an enterprise level.

• Create new or modify existing Talend and SSIS jobs to load into AWS Redshift and SQL Server database to support performance, data quality, and data governance.

• Design and architect ETL load strategies needed to support required staging, warehouse, or data marts. Manage data using AWS Redshift, RDS, EMR, Data Pipeline, Kinesis and DynamoDB

• Code review Talend and SSIS jobs to ensure they comply with project standards and best practices.

• Setup IaaS (Infrastructure as a Service) for EC2, VPC, EBS, SNS, SQS, S3, and Glacier

• Use AWS CloudFormation to model and provision Infrastructure resources in an automated and secure manner.

• Migrate existing programs from SSIS – SQL Server to Talend – AWS Redshift

• Responsible for the accurate documentation and gathering of appropriate metadata for all newly developed ETL procedures using available tools.

• Build Data pipelines through CI/CD (Continuous Integration / Continuous Deployment).

• Develop detailed implementation plans estimating duration and identifying dependencies; while mentoring/assisting others.

• Tools & Technologies used: Talend, SSIS SQL Server Integration Service, MS SQL Server, AWS Redshift, AWS S3, AWS EC2, AWS S3, AWS Kinesis, DynamoDB, CloudFormation

Work Location :

Various unanticipated work locations throughout the United States; relocation may be required. Must be willing to relocate.

Minimum Requirements:

Education : Bachelor of Science degree in Information Technology or its equivalent

Experience:

None

Job Order No : 9482901.

This position is eligible for a referral bonus through our employee referral program

Position : Sr. ETL Developer

Job Duties :

70% of Worktime

• Design and develop ETL load strategies, update strategies, error processing, mapping dependencies, batch processing and balance control approaches.

• Performance Tuning and Query Optimization using several types of Hints, Partitioning, Bulking techniques and Indexes. Improve project delivery and provide recommendations for process improvement

• Design and involve in development of Mapping specifications, Physical Flow diagrams and Build documents.

• Create design/architecture plans and solution requirements and deliver project capabilities.

• Informatica PowerCenter and all features will be used extensively in migrating data from different source systems to target. Drive strategy, innovation, Agile knowledge, and best practices on project engagements.

• Drive innovation and operational performance in the deployment of new functionality, services, and products.

• Validate files and schedule jobs for preprocessing and post processing using UNIX shell scripts.

• Writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.

20% of Worktime

• Address challenges of systems integration, compatibility, and multiple platform integration.

• Collaborate with cross-functional teams in driving operating and service excellence

• Conduct and participate in peer code reviews and suggesting best coding practices in the current trend across the team mates.

10% of Worktime

• Involved in ETL estimates and task dependencies for Built, Implementation and deploy phase for Application.

Work Location :

Various unanticipated work locations throughout the United States; relocation may be required. Must be willing to relocate.

Minimum Requirements:

Education : Bachelor’s Degree in Computer Science, or a related area, or the equivalent.

Experience:

None

Job Order No : 9473215.

This position is eligible for a referral bonus through our employee referral program

Position : Sr. ETL Developer

Job Duties :

Design and develop ETL load strategies, update strategies, error processing, mapping dependencies, batch processing and balance control approaches; Performance Tuning and Query Optimization using several types of IIints, Partitioning, Bulking techniques and Indexes. Improve project delivery and provide recommendations for process improvement; Design and involve in development of Mapping specifications, Physical Flow diagrams and Build documents; Create design/architecture plans and solution requirements and deliver project capabilities; Informatica PowerCenter and all features will be used extensively in migrating data from different source systems to target. Drive strategy, innovation, Agile knowledge, and best practices on project engagements; Drive innovation and operational performance in the deployment of new functionality, services, and products; Validate files and schedule jobs for preprocessing and post processing using UNIX shell scripts; Writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle. Collaborate with cross-functional teams in driving operating and service excellence; Conduct and participate in peer code reviews and suggesting best coding practices in the current trend across the team mates. Address challenges of systems integration, compatibility, and multiple platform integration; Involved in ETL estimates and task dependencies for Built, Implementation and deploy phase for Application.

Work Location :

Various unanticipated work locations throughout the United States; relocation may be required. Must be willing to relocate.

Minimum Requirements:

Education : Bachelor’s Degree in Computer Science, or a related area

Experience:

None

Job Order No : 8913712.

This position is eligible for a referral bonus through our employee referral program

Position : Sr. ETL Developer

Job Duties :

Under limited supervision, perform software analysis, design, development, implementation, testing and support of complex ETL applications; provide expertise during SDLC; analyze business and technical requirements; using advanced theoretical concepts, design, implement and maintain ETL architecture and modular ETL applications; create database objects, including tables, views, triggers, indexes, stored procedures and functions; create complex reports; create OLAP cubes; define referenced relationships and identify KPIs; build and maintain modular ETL applications; coordinate with other teams to develop high performing ETL and maintain consistent functions; develop database schemas; design and develop packages to extract and transform data for data migration; performance tune packages and solutions; perform query optimization; monitor and tune performance; create unit test cases; develop and coordinate software system testing and validation procedures; perform unit and system integration testing; provide QA and production support, fix bugs and troubleshoot technical problems; review code; assist/mentor less experienced teammates; and use: Windows, UNIX, Oracle, SQL Server, TFS, SharePoint, T-SQL, VSS, Erwin, SSRS, SSIS, SSAS, PPS, VB.Net, Asp.Net, C#, C, C++, HTML, XML and related tools.

Minimum Qualifications Education

• Master degree in Computer Science, Computer or Software Engineering, Information Technology or in a related field of study (will accept equivalent foreign degree);

• Experience : Two (2) years of experience as a Software Developer, Systems Analyst, Programmer or in a related occupation;

• Other Requirements :

• Experience must include two (2) years of work with SSRS, SSIS, PPS and SharePoint; must be willing to relocate.

• Job Order No : 8819722.

• This position is eligible for a referral bonus through our employee referral program

• Position : Sr. ETL Developer

• Job Duties :

Under limited supervision, perform application system analysis, design and development using ETL and BI tools; coordinate SDLC; gather and interpret functional specifications and user requirements; prepare design documentation and functional and technical specifications; analyze, design and develop ETL strategies and processes; write ETL specifications; design and develop data warehousing and data mart; perform data cleansing; develop, execute and automate mappings and workflows; store, retrieve, and manipulate data for analysis of system capabilities and requirements; coordinate with data mapping team to understand and develop source and target mapping rules; determine incremental loading mappings; create mappings and mapplets; implement process to extract, transform and load data from various formats to data warehouse; migrate data, schedule jobs and create reports; execute performance tuning; develop and deliver ETL code; prepare test plan, test cases and execute unit and integration testing; mentor/assist less experienced team members with the above, as necessary; maintain system documentation; and use: Windows, Linux, Oracle, JBoss, Informatica, Flat Files, TOAD, Unix Shell Scripting, IDQ, SQL, Visio, Java, Java Script and related tools.

Minimum Qualifications Education

• Master degree in Computer Science, Computer Engineering, Information Science/Technology, or in a related field of study (will accept equivalent foreign degree);

• Experience : One (1) year of experience as a Software Developer, Business Intelligence Analyst, Data Warehousing Specialist or in a related occupation;

• Other Requirements :

• Experience must include one (1) year of work with Unix Shell Scripting, Informatica, ETL code, IDQ and Mapplets; must be willing to relocate.

• Job Order No : 8411215.

• This position is eligible for a referral bonus through our employee referral program

• Position : Sr. ETL Developer

• Job Duties :

Under limited supervision, design, develop, test and install complex SAP, Netweaver, Enterprise Portal and other application systems; gather and interpret functional specifications and user requirements; responsible for full SDLC; create complex SSAS cubes with multiple fact measure groups; participate in strategy meetings; design and develop SSIS packages, stored procedures, configuration tables, and functions; perform SQL queries to test data warehouses; define transport strategy and configure transport management system across landscape; perform data extraction, transformation and loading and migrate BI reports; schedule and monitor background jobs; perform user maintenance and security administration; install, configure, and patch BPC; perform memory management and performance tune SAP systems; support performance test phases and assist with integration testing; document system maintenance procedures and knowledge transfer; solve production issues; and used the following tools/technologies: Windows, IIS, SQL Server, DB2, DataStage, Informatica, SSIS, SSAS, TIDAL, Visual Source Safe, WCF, .Net Framework, ADO.Net, ASP.Net, VB.Net, C#, CSS, XML, HTML, JavaScript, Java and related tools.

Minimum Qualifications Education

• Bachelor degree in Computer Science, Information Systems, Electronic Engineering, or in a related field of study (will accept equivalent foreign degree);

• Experience : Five (5) years of progressive experience as a Software Developer, Systems Analyst, or in a related occupation;

• Other Requirements :

• Experience must include five (5) years of work with SQL Server, SSIS, SSAS, WCF and .Net Framework; must be willing to relocate.

• Job Order No : 8033029.

• This position is eligible for a referral bonus through our employee referral program

• Position : Sr. ETL Developer

• Job Duties :

Under limited supervision, perform complex software analysis, design and development using ETL tools; coordinate SDLC; gather and interpret functional specifications and user requirements; prepare design documentation and functional and technical specifications; create conceptual, logical and physical data models; design and develop data warehousing and data mart applications; develop ETL extracts; develop, execute and automate mappings and workflows; store, retrieve, and manipulate data for analysis of system capabilities and requirements; work with data mapping team to understand and develop source and target mapping rules; design and build graphs to unload data from source systems; implement process to extract, transform and load data from various formats to data warehouse; migrate data, schedule jobs and create reports; execute performance tuning; prepare test plan, test cases and execute unit testing; mentor/assist lower level team members with the above, as necessary; and utilize Windows, UNIX, Oracle, Teradata, Informatica, Business Objects, Flat Files, Abinitio, Win Runner, Control-M, Autosys, VB, PL/SQL, C, UNIX Shell Scripting, and related tools.

Minimum Qualifications Education

• Master degree in Computer Science, Computer Applications Computer Engineering, or in a related field of study (will accept equivalent foreign degree);

• Experience : Two (2) years of experience as a Software Developer, Systems Analyst, Programmer, or in a related occupation;

• Other Requirements :

• Experience must include work with Oracle, Teradata, Informatica, Abinitio and UNIX Shell Scripting; job may require relocation within the U.S.; must be willing to relocate.

• Job Order No : 7468343.

• This position is eligible for a referral bonus through our employee referral program

• Position : Sr. ETL Developer

• Job Duties :

Under limited supervision, perform complex software analysis, design and development using ETL tools; responsible for SDLC; gather and interpret functional specifications and user requirements; prepare design documentation and functional and technical specifications; create conceptual, logical and physical data models; create database objects and develop highly complex original code; design and implement ETL data model; create staging, source and target tables; develop, execute and automate mappings and workflows; store, retrieve, and manipulate data for analysis of system capabilities and requirements; develop source and target mapping rules; implement process to extract, transform and load data from various formats; oversee and deliver development artifacts from offshore teams; migrate data and schedule jobs; implement error handling to validate data integrity/completeness; review release code and changes for production; oversee systems testing and platform/application migration to production; mentor/assist lower level team members with the above, as necessary; develop new documentation, technical procedures and user guides; and use UNIX, Windows, Oracle, Teradata, SQL Server, Microstrategy, Business Objects, Cognos, Ab Initio, SQL, PL/SQL, Java, UNIX Shell Scripting, VB, C, and related tools.

Minimum Qualifications Education

• Bachelor degree in Business Administration, Computer Science, Computer Engineering, or in a related field of study (will accept equivalent foreign degree);

• Experience : Five (5) years of progressive experience as a Software Developer, Systems Analyst, Programmer, or in a related occupation;

• Other Requirements :

• Experience must include work with Teradata, Oracle, Ab Initio, Microstrategy, UNIX Shell Scripting; job may require relocation within the U.S.; must be willing to relocate.

• Job Order No : 7466822.

• This position is eligible for a referral bonus through our employee referral program

• Position : Sr. ETL Developer

• Job Duties :

Under limited supervision, perform moderately complex software analysis, design and development using ETL tools; provide expertise during SDLC; gather and interpret functional specifications and user requirements; prepare design documentation and functional and technical specifications; create conceptual, logical and physical data models; analyze databases, and coordinate the design/development of database solutions; create database objects based on business requirements; design and implement ETL data model and create staging, source and target tables; develop, execute and automate mappings and workflows; store, retrieve, and manipulate data for analysis of system capabilities and requirements; work with data mapping team to understand and develop source and target mapping rules; implement process to extract, transform and load data from various formats; migrate data; schedule jobs; implement error handling to validate data integrity and completeness; mentor/assist lower level team members with the above, as necessary; and utilize Windows, UNIX, Linux, Oracle, Netezza, Teradata, SQL*Loader, SQL, PL/SQL, TOAD, Putty, SQL, Postgres, SAP, C++, Java, and related tools.

Minimum Qualifications Education

• Master degree in Computer Science, Computer Engineering, or in a related field of study (will accept equivalent foreign degree);

• Experience : One (1) year of experience as a Software Developer, Systems Analyst, Programmer, or in a related occupation.

• Other Requirements :

• Experience must include work with UNIX, Oracle, Netezza, PL/SQL, and Java; job may require relocation within the U.S.; must be willing to relocate.

• Job Order No : 6823000.

• This position is eligible for a referral bonus through our employee referral program.

• Position : Sr. ETL Developer

• Job Duties :

Under limited supervision, analyze, design, develop, implement and troubleshoot moderately complex data warehouse application solutions; gather and interpret functional specifications and user requirements and develop solutions; develop technical documentation; coordinate the development of the data mart and data warehouse; perform application data integration development; implement metadata processes and frameworks; implement business rules; create stored procedures, packages, functions and triggers; develop ETL mappings; develop and schedule ETL workflows; create data mappings and packages to load data from various sources to destination; execute performance tuning and SQL query tuning; develop test cases, perform unit testing, troubleshoot scripts, fix bugs and address production issues; prepare user documentation; mentor/assist lower level team members with the above, as necessary; and use UNIX, DB2, Oracle, SQL Server, OLAP, OLTP, TOAD, Flat Files, Informatica, PL/SQL, SQL, UNIX Shell Scripting, Java, J2EE, C/C++, and related tools.

Minimum Qualifications Education

• Master degree in Computer Science, Computer Engineering, or in a related field of study (will accept equivalent foreign degree);

• Experience : One (1) year of experience as a Data Warehousing Specialist, Software Developer, Systems Analyst, or in a related occupation.

• Other Requirements :

• Experience must include work with DB2, SQL Server, Informatica, performance tuning, and Unix Shell Scripting; job may require relocation within the U.S.; must be willing to relocate.

• Job Order No : 6804590.

• This position is eligible for a referral bonus through our employee referral program.

• Position : Sr. ETL Developer

• Job Duties :

Under limited supervision, analyze, design, develop, implement and troubleshoot data warehouse application solutions; gather and interpret functional specifications and user requirements and develop software solutions; analyze functional/business requirements and prepare estimation of work; coordinate the development of the data mart; define relationships between the fact and dimension tables using keys; develop PL/SQL stored procedures, functions, packages, triggers, cursors, bulk collections and exception handling; analyze query plans and execute performance tuning; write code to enhance programs and develop new programs; create multidimensional cubes and interfaces; create data mappings and packages to load data from various sources to destination; develop and direct software system testing and validation procedures, and develop enhancements and modifications; develop test plans, test scripts and test cases for manual and automated testing; troubleshoot scripts, fix bugs and address production issues; mentor/assist lower level programmers with the above, as necessary; and use Windows, UNIX, Sun Solaris, Oracle, SQL Server, T-SQL, Teradata, PL/SQL Developer, SQL Loader, TOAD, Jams, BTEQ, Fast Load, PowerBuilder, SSIS, SSAS, OLAP and related tools.

Minimum Qualifications Education

• Master degree in Computer Science, Computer Engineering, Information Systems, or in a related field of study (will accept equivalent foreign degree);

• Experience : One (1) year of experience as a Data Warehousing Specialist, Software Developer, Systems Analyst, or in a related occupation.

• Other Requirements :

• Experience must include work with SQL Server, Teradata, Jams, SSIS and SSAS; job may require relocation within the U.S.; must be willing to relocate.

• Job Order No : 6686233.

• This position is eligible for a referral bonus through our employee referral program.