Data Warehouse ETL Developer -South Florida or Philadelphia - Georgia IT Inc.
South Florida or Philadelphia, NJ
About the Job
Position Title: Data Warehouse ETL Developer
Location: South Florida or Philadelphia
Duration: 1 year
Rate : To be discussed
Job Summary:
A Senior DW ETL Developer is needed to join a team responsible for design and the development of analytical data marts and business intelligence 2.0 applications based on data mining and visualization technologies. To qualify, you must have worked on a very large SQL Server databases (more than 1-2 TB); must have excellent T-SQL, SSIS and be able to write, debug, and optimize ETL packages and complex stored procedures. A university degree in information technology is also required and provable experience with SQL Server 2012 SSIS and secondarily .NET, C# are preferred. Being eager to learn new technologies and advanced analytics is a plus.
Job Components
* The client is looking for HL7 and few EDI formats like 835, 837 etc. Heavy health care experience.
* Responsible for the design, coding, testing, tuning and maintenance of SQL "data marts " to support "in memory based BI applications.
* Work directly with Modelers/Architects/DBA on data modeling, logical/physical schema design, SQL query tuning; and the application of data-related business rules while assisting in troubleshooting, debugging, and issue resolution
* Communicate effectively with end users, peers, and management regarding assignments, and must have a can-do attitude and a desire to provide solutions
* Delivering projects with a high-level of data quality and integrity
* Meet deadlines and possess a proven record of successful project execution and delivery.
* Demonstrate knowledge of SDLC processes and procedures adjusted for a Rapid Application Development methodology (agile)
Qualifications
* 5-7 years experience developing analytical databases, healthcare industry experience a must
* Strong understanding of SDLC. Expertise in documenting all the phases of DWH projects
* Extensive experience in designing and developing of complex mappings, applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter, joiner and sorter transformations
* Experience in integration of various data sources like Oracle, DB2, SQL Server, and Flat Files into the staging area
* Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Modify, Aggregator, XML parsing stages. Good experience with ETL tools: SSIS or Data Stage, Informatica
* Good knowledge in identifying performance bottlenecks and also in tuning the Mappings and Sessions
* Expert knowledge of Microsoft SQL Server, SSIS, T-SQL Stored
* Procedures, Triggers, DTS, and data quering optimization
* Excellent communication, interpersonal, analytical and leadership skills, self-motivated, quick learner and a team player Ability to work in a team and individually, independent thinker, focused on meeting deliverables in a remote environment
* Clear understanding of RDBMS, ER, 3rd n forms, OLAP dimensional Models
* IMS knowledge is also a Plus not required.
Location: South Florida or Philadelphia
Duration: 1 year
Rate : To be discussed
Job Summary:
A Senior DW ETL Developer is needed to join a team responsible for design and the development of analytical data marts and business intelligence 2.0 applications based on data mining and visualization technologies. To qualify, you must have worked on a very large SQL Server databases (more than 1-2 TB); must have excellent T-SQL, SSIS and be able to write, debug, and optimize ETL packages and complex stored procedures. A university degree in information technology is also required and provable experience with SQL Server 2012 SSIS and secondarily .NET, C# are preferred. Being eager to learn new technologies and advanced analytics is a plus.
Job Components
* The client is looking for HL7 and few EDI formats like 835, 837 etc. Heavy health care experience.
* Responsible for the design, coding, testing, tuning and maintenance of SQL "data marts " to support "in memory based BI applications.
* Work directly with Modelers/Architects/DBA on data modeling, logical/physical schema design, SQL query tuning; and the application of data-related business rules while assisting in troubleshooting, debugging, and issue resolution
* Communicate effectively with end users, peers, and management regarding assignments, and must have a can-do attitude and a desire to provide solutions
* Delivering projects with a high-level of data quality and integrity
* Meet deadlines and possess a proven record of successful project execution and delivery.
* Demonstrate knowledge of SDLC processes and procedures adjusted for a Rapid Application Development methodology (agile)
Qualifications
* 5-7 years experience developing analytical databases, healthcare industry experience a must
* Strong understanding of SDLC. Expertise in documenting all the phases of DWH projects
* Extensive experience in designing and developing of complex mappings, applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter, joiner and sorter transformations
* Experience in integration of various data sources like Oracle, DB2, SQL Server, and Flat Files into the staging area
* Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Modify, Aggregator, XML parsing stages. Good experience with ETL tools: SSIS or Data Stage, Informatica
* Good knowledge in identifying performance bottlenecks and also in tuning the Mappings and Sessions
* Expert knowledge of Microsoft SQL Server, SSIS, T-SQL Stored
* Procedures, Triggers, DTS, and data quering optimization
* Excellent communication, interpersonal, analytical and leadership skills, self-motivated, quick learner and a team player Ability to work in a team and individually, independent thinker, focused on meeting deliverables in a remote environment
* Clear understanding of RDBMS, ER, 3rd n forms, OLAP dimensional Models
* IMS knowledge is also a Plus not required.
Source : Georgia IT Inc.