Hi, If you are Interested and available for the Job, Please revert back with latest resume, expected pay rate, availability and other details required for submission to n...@apetan.com.
*Client is TCS* *MOI: Telephonic+ Skype* *Job title: Data Analyst* *Work Location: Chicago* *No of positions: 8* *Experience – 4 to 8 years * *Essential Duties and Responsibilities: * · Strong knowledge of SQL/T-SQL · Interpret data, analyze results using statistical techniques and provide ongoing reports · Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality · Acquire data from primary or secondary data sources and maintain databases/data systems · Identify, analyze, and interpret trends or patterns in complex data sets · Filter and “clean” data, and review computer reports, printouts, and performance indicators to locate and correct code problems · Work closely with management to prioritize business and information needs · Profile and understand large amounts of source data available, including structured, semi-structured or web activity data · Work with data originators to fill in gaps in the data collected, and/or to adjust source-system data structures to facilitate analysis and integration with other company data. · Ability to develop/troubleshoot/enhance complex Stored Procedures for data loadings/transformation. · Strong Working knowledge of other enterprise reporting tools · Regular and periodic maintenance/upgrade of data warehouse SQL server, BI tools like Datastage or SSIS / SSRS. · Be the primary POC for all technical issues related to the Data warehouse solutions/Platform. Learn and support new tools on the job. · Works with business leaders to develop detailed business requirements, creating functional design, gap analysis, technical design, and traceability matrices. · Data management (Data flow, Data profiling, Definition/Meta data, Master Data Management, Reference Data, Data Quality, Data Lineage, Data Transformation, Modeling, Analysis, Reporting - All are not required) · Perform other related duties as required. · *Nice to have* - Knowledge and experience on statistical packages for analysing large datasets (Excel, SPSS, SAS etc) *Education and/or Work Experience Requirements: * · Excellent verbal and written communication skills, including ability to effectively communicate with internal and external customers · Proven working experience as a data analyst · Excellent computer proficiency (MS Office – Word, Excel and Outlook) · Must be able to work under pressure and meet deadlines, while maintaining a positive attitude and providing exemplary customer service · Ability to work independently and to carry out assignments to completion within parameters of instructions given, prescribed routines, and standard accepted practices · Technical expertise regarding data models, database design development, data mining and segmentation techniques · Strong knowledge of and experience with reporting packages (Business Objects etc), databases (SQL etc), programming (XML, Javascript, or ETL frameworks) · Associate degree preferred *Job title: Sr. Data Analyst* *Work Location: NY/NJ* *No of positions: 9* *Experience – 6 to 8 years * *Essential Duties and Responsibilities: * · Strong knowledge of SQL/T-SQL · Interpret data, analyze results using statistical techniques and provide ongoing reports · Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality · Acquire data from primary or secondary data sources and maintain databases/data systems · Identify, analyze, and interpret trends or patterns in complex data sets · Filter and “clean” data, and review computer reports, printouts, and performance indicators to locate and correct code problems · Work closely with management to prioritize business and information needs · Profile and understand large amounts of source data available, including structured, semi-structured or web activity data · Work with data originators to fill in gaps in the data collected, and/or to adjust source-system data structures to facilitate analysis and integration with other company data. · Ability to develop/troubleshoot/enhance complex Stored Procedures for data loadings/transformation. · Strong Working knowledge of other enterprise reporting tools · Regular and periodic maintenance/upgrade of data warehouse SQL server, BI tools like Datastage or SSIS / SSRS. · Be the primary POC for all technical issues related to the Data warehouse solutions/Platform. Learn and support new tools on the job. · Works with business leaders to develop detailed business requirements, creating functional design, gap analysis, technical design, and traceability matrices. · Data management (Data flow, Data profiling, Definition/Meta data, Master Data Management, Reference Data, Data Quality, Data Lineage, Data Transformation, Modeling, Analysis, Reporting - All are not required) · Perform other related duties as required. · *Nice to have* - Knowledge and experience on statistical packages for analysing large datasets (Excel, SPSS, SAS etc) *Education and/or Work Experience Requirements: * · Excellent verbal and written communication skills, including ability to effectively communicate with internal and external customers · Proven working experience as a data analyst · Excellent computer proficiency (MS Office – Word, Excel and Outlook) · Must be able to work under pressure and meet deadlines, while maintaining a positive attitude and providing exemplary customer service · Ability to work independently and to carry out assignments to completion within parameters of instructions given, prescribed routines, and standard accepted practices · Technical expertise regarding data models, database design development, data mining and segmentation techniques · Strong knowledge of and experience with reporting packages (Business Objects etc), databases (SQL etc), programming (XML, Javascript, or ETL frameworks) · Associate degree preferred *Job title: SAS Data Analyst* *Work Location: Buffalo NY/London/France/Toronto/Mexico City* *No of positions :* *Experience – 6 to 8 years * *Essential Duties and Responsibilities: * · Base SAS and SAS Data Management · SAS DataFlux/Analytics and SQL · Strong business analysis skills · Data management (Data flow, Data profiling, Definition/Meta data, Master Data Management, Reference Data, Data Quality, Data Lineage, Data Transformation, Modeling, Analysis, Reporting - All are not required) · Data warehouse into SAS environment · Query on data sets in SAS to execute reports. · Data lineage (for all data elements) · End user interaction to understand currently applied business logics · Documentation (either in Office or directly into Collibra) of data information and meta-data where applicable · Engaging with IT to verify source to target mapping (e.g. if data element is sourced from DW, then where does DW get that data?) *Nice to have* - Exposure on newer Hadoop based technologies like Hive, Map Reduce, Pig *Education and/or Work Experience Requirements: * · Excellent verbal and written communication skills, including ability to effectively communicate with internal and external customers · Excellent computer proficiency (MS Office – Word, Excel and Outlook) · Must be able to work under pressure and meet deadlines, while maintaining a positive attitude and providing exemplary customer service · Ability to work independently and to carry out assignments to completion within parameters of instructions given, prescribed routines, and standard accepted practices · Associate degree preferred *Job title: SAS DI Developer / Analyst * *Work Location: NY/NJ* *No of positions : 1* *Experience – 4 to 8 years on SAS Data Integration Studio Experience* *Essential Duties and Responsibilities: * · Demonstrated ability to perform as SAS developer using SAS Data Integration Studio. · Experience in extracting, transforming and loading source data into the SAS environment from multiple sources including major DBMS and application system transaction files, third-party software packages, and spreadsheet applications. · Understanding of ER and Dimensional Models. • Experience working with Version Control (SVN, CVS, PVCS). · Experience working with a Scheduling Tool. · Strong familiarity with Teradata development and execution environments, and state-of-the- industry reporting and data management tools. · Knowledgeable and experienced in implementing and optimizing Windows-based SAS products within existing infrastructures. · Ability to effectively communicate with various stakeholders: technical and end-user, staff and management. · Ability to work independently. · Experience of 4-8 years, preferably *Nice to have* - Exposure on newer Hadoop based technologies like Hive, Map Reduce, Pig *Education and/or Work Experience Requirements: * · Excellent verbal and written communication skills, including ability to effectively communicate with internal and external customers · Excellent computer proficiency (MS Office – Word, Excel and Outlook) · Must be able to work under pressure and meet deadlines, while maintaining a positive attitude and providing exemplary customer service · Ability to work independently and to carry out assignments to completion within parameters of instructions given, prescribed routines, and standard accepted practices · Associate degree preferred *Nick G.* |* Technical Recruiter **| **Apetan Consulting LLC |* *Tel: 201-620-9700 * 141 **| **15 Union Avenue, office # 6, Rutherford, New Jersey 07070 | * *Mail :-** n...@apetan.com <n...@apetan.com> **| **www.apetan.com* <http://www.apetan.com/> | -- You received this message because you are subscribed to the Google Groups "mainframe" group. To unsubscribe from this group and stop receiving emails from it, send an email to mainframe+unsubscr...@googlegroups.com. To post to this group, send email to mainframe@googlegroups.com. Visit this group at https://groups.google.com/group/mainframe. For more options, visit https://groups.google.com/d/optout.
