HI All,
Hope you are doing great!!!!!
We do have multiple openings available for below position if you do have any of your consultant available please share with me at ankur@360itpro.com or can give me call back at 510-254-3300 EXT 136
Job Role: Senior ETL Developer (Lead)
Location: Atlanta, GA (Need local only)
Duration: Long Term
INTERVIEW PROCESS: PHONE SCREEN AND IN-PERSON INTERVIEW MUST - LOCAL CONSULTANT ONLY OR WHO CAN COME FOR FACE-TO-FACE INTERVIEW AT HIS/HER OWN COST
Visa copy required at the time of submission
Job Summary
Leads, Develops, maintains, and integrates processes which extract data from standardized or varied data sources; transforms data for storing in proper formats and structures for querying and analysis; loads data into target data structures, Operational data store (ODS), data mart, or data warehouse; Participates on a project team working closely with internal and external clients, business analysts and other team members to ensure that the end to end designs meet the business and data requirements; responsible for unit testing, implementation of solution, and continuous maintenance and support of existing solutions.
Principal Duties & Responsibilities
§ Exercises independent decision making to creates processes which initiate the ETL or Batch cycle; develops streaming processes for extracted data loading to destination database, including on-the-fly processing where extract and transformation phase to no go to persistent storage; Performs data profiling of source data in order to identify data quality issues and anomalies, business knowledge embedded in data; natural keys, and meta data information
§ Creates data validation rule on source data to confirm the data has correct and/or expected values; Writes alternate workflow steps or reports back to the source for further analysis and correction of incorrect record(s) when validation rules are not passed
§ Develops processes to be applied to extracted source data to move to target state; Writes data cleansing functions to get data to proper prunes data set to include only fields needed; translates source code values to target value; Standardizes free form values to codes; Derives new values through calculations on existing fields; Merges data from multiple in order to generate on consolidated source for the target
§ Sorts and Aggregates records into rollup where multiple records are represented; Creates surrogate-key values to use in place of multiple natural keys; Turns multiple columns into multiple rows or vice–versa (Transposing or Pivoting); Splits multi-valued column data into multiple columns; Disaggregates repeating columns into separate detail table(s); Creates lookup tables; Looks up and validates reference information as part of data validation
§ Creates and applies data validation step process in order to perform partial, full or no record's rejection; Writes processes which handle exceptions and/or move records exceptions to alternate Transform step(s)
§ Develops processes which load the transformed data into end target systems (database, file, application, etc.); may apply different techniques based on business needs including inserting new data into target; Over write existing data with cumulative information; Updates existing data at some frequency; Creates data validation steps in this layer to ensure loaded data
§ Creates process cleanup after complex ETL processes which release resources used to run ETL; Creates processes to archive data
§ Participates in project collaboration meeting with clients, business analysts, and team members in order to analyze and clarify business requirements; Translates business requirements into detailed technical specification
§ Works with project teams to define and design scope for each project; Creates unit test cases to ensure the application meets the needs of the business
§ Ensures proper configuration management and change controls are implemented; Provides technical assistance and cross training to other team members
§ Designs and implements technology best practices, guidelines and repeatable processes; Prepares and presents status updates on various projects
Education & Experience:
§ Bachelor's degree in programming/systems or computer science (preferred), specialized training, certification, and at least five to six years of programming experience; or an equivalent combination of education and experience as it applies to this job profile
§ Requires experience and understanding of multiple programming languages and applicable applications including SQL and ETL.
Job Knowledge & Skills:
SQL & Relational Databases | Advanced |
XML | Advanced |
XSL | Advanced |
Business Intelligence:
ETL Techniques | Advanced |
Data Modeling | Advanced |
Data Warehousing/Business Intelligence | Advanced |
Meta Data Repository | Intermediate |
MS SQL Server | Advanced |
Unfeigned Regards,
Ankur Bhatia | Sr. Technical Recruiter - TAG US | 360 IT Professionals Inc.
O: 510-254-3300 EXT 136
E: Ankur@360itpro.com
Skype: Ankur.bhatia91 | My LinkedIn: https://www.linkedin.com/pub/ankur-bhatia/69/b34/795
--
All Job Openings : http://groups.google.com/group/jobjunction/topics?hl=en
You received this message because you are subscribed to the Google Groups "Job Junction" group.
If you are a job seeker please join the group using the link http://groups.google.com/group/jobjunction/subscribe or you can join group or add Job Junction as your friend in Facebook (Search for Job Junction) or you can also follow my blog http://jobjunctionglobal.blogspot.com/
If you have any requirement to share please send the same with all job details, email ID to which the resume has to be sent to jobjunction@googlegroups.com and jobjunctionglobal@groups.facebook.com
To unsubscribe from this group, send email to jobjunction+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jobjunction?hl=en
---
You received this message because you are subscribed to the Google Groups "Job Junction" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jobjunction+unsubscribe@googlegroups.com.
Visit this group at https://groups.google.com/group/jobjunction.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment