Etl developer job description

6+ Months

Requirements:

• Over 8-10 years of experience in the field of Information Technology with proficiency in ETL design/development and Data Warehouse Implementation/development.

• Experienced in Design, Development and Implementation of large - scale projects in Financial, Shipping and Retail industries using Data Warehousing ETL tools (Pentaho) and Business Intelligence tool.

• Knowledge about Software Development Lifecycle (SDLC), Agile, Application Maintenance Change Process (AMCP).

• Excellent data analysis skills.

• Experience in Architecting and building Data Warehouse systems and Business Intelligence systems including ETL using Pentaho BI Suite (Pentaho Data Integration Designer / Kettle).

• Hands-on experience on Data warehouse Star Schema Modeling, Snow-Flake Modeling, FACT Dimension Tables, Physical and Logical Data Modeling.

• Installed and configured Pentaho BI Server on different operating systems like Red Hat, Linux and Windows Server.

• Hands on experience on the whole ETL (Extract Transformation Load) process.

• Experience in creating ETL transformations and jobs using Pentaho Kettle Spoon designer and Pentaho Data Integration Designer and scheduling them on Pentaho BI Server.

• Used bunch of steps in Pentaho transformations including Row Normalizer, Row Demoralizer, Database Lookup, Database Join, Calculator, Add Sequence, Add Constants and various types of inputs and outputs for various data sources including Tables, Access, Text File, Excel and CSV file.

• Integrating Kettle (ETL) with Hadoop and other various NoSQL data stores can be found in the Pentaho Big Data Plugin. This is a Kettle plugin and provides connectors to HDFS, MapReduce, HBase, Cassandra, MongoDB, CouchDB that work across Pentaho Data Integration.

• Loaded unstructured data into Hadoop File System (HDFS)

• Experience in performing Data Masking/Protection using Pentaho Data Integration (Kettle).

• Experience in writing shell scripting for various ETL needs.

• Deep knowledge of RDBMS (SQL Server, MySQL, DB2 etc) and NoSQL databases such as MongoDB, DynamoDB and Cassandra.

• Proficient in writing Confidential - SQL Statements, Complex Stored Procedures, Dynamic SQL queries, Batches, Scripts, Functions, Triggers, Views, Cursors and Query Optimization.

• Quick understanding of Relational Source Database Systems and data models for building accurate transformation logic that can be used in Data Migration and Data Integration.

• Good to have Supply Chain Knowledge.

• Motivated team player with excellent communication, interpersonal, analytical and problem-solving skills.

Kforce has a client that is seeking an ETL Developer in Atlanta, GA.Summary:In this role, the ETL Developer is responsible for the design, development and support of ETL (Extraction, Transformation and Loading) components, which will be used to move large amounts of data from source data and software application data stores into the optimized operational databases. The ETL Developer will be responsible for understanding requirements, designing, developing, and partnering with internal and external IT professionals. This role documents all technical and system specifications documents for all ETL processes and perform unit tests on all processes and prepare required programs and script.Responsibilities:

* Develop, maintain, and administer complex ETL processes using MS SQL Server 2005/2008/2012 (DTS and SSIS)
* Participates in the design, development and implementation of complex data integration projects

* Provides thought leadership on data and system architecture, system administration, schedule management, performance tuning, and expansion

* Develop, manage and maintain data models, including physical and logical models of the data warehouse, data marts, development and staging areas and source systems as necessary to meet new and changing business requirements

* Performs root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all ETL applications

* Establishes methods and procedures for tracking data quality, completeness, redundancy and improvement; and processes for governing the identification, collection and use of metadata to assure metadata is accurate and valid in the business intelligence environments

* Reviewing requirements, contributing to design components of ongoing and upcoming projects, and effectively estimating development effort

* Candidates qualifying for this position will have similar experience along with the skills and abilities to perform the duties mentioned

* Any relevant education and/or training will be considered a plus

Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.*Compensation Type:*Years

Job DescriptionDue to the current COVID-19 status, candidates will not be required to work within the physical work location at this time. When COVID-19 restrictions are lifted, they will be required to be located within the proximity of the assigned client's location at Columbia, SC - Lafayette, LA - Knowxville, TN - Plano, TX

The candidate will be required to be a solid ETL Developer, AWS with excellent technical and communication skills. The candidate must be motivated and must be able to perform on their own with little or no guidance.
Your future duties and responsibilities
As part of this role, it is required to solve moderately complex problems that require some independent thinking while adhering to agile practices, coding standards, testing methods, and source management guidelines established by the IT group. In addition, the candidate will need to be part of regular code reviews from their peers and senior staff.

The candidate should be good at problem-solving and independently interact with Business users and external partners/vendors for soliciting requirements of what needs to be coded. The candidate will be required to provide guidance to junior-level developers. Be able to articulate opinions on software development issues to the team or workgroup. Demonstrate an understanding and adherence to the Client's vision, values, and principles. Must be able to adjust and cater to changing needs of businesses as they evolve. Foresees potential technical issues and recommends approaches to solve issues. Exhibits a positive can-do attitude towards peers, colleagues, and customers.

Required qualifications to be successful in this role
• 5+ years of relevant experience with ETL
• Interact with external vendors and internal business/product owner team to understand the business requirements
• Analyze requirements/user stories and come up with Technical design
• Work with Database Administrators, Data Modelers, and Business Analysts on solution design and implementation
• Perform Maintenance and Support Activities for application
• Develop /Update Unix shell scripts
• Identify and implement innovation/process impro
• AbInition experience is a plus
• Ability to work in a fast-paced Agile environment.
• Key Skills Needed: Oracle DBA, PL/SQL, Confluence, JIRA, Unix Shell Scripts

Desired Skillset
ETL Developer, AWS

Educational Requirements
Bachelor's degree in Computer Science, Information Systems, or related field
Professional certification(s) desired
Post-graduate degree desired


**Talteam Inc. is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability.**